﻿
CREATE PROCEDURE sp_UserProfile_Insert 
	-- Add the parameters for the stored procedure here
	(
				@UserKey int,
				@UserFullName varchar(150),
				@UserSex char(1),
				@UserDateOfBirth datetime,
				@UserAlternateEmailID varchar(150),
				@UserContactNumber varchar(50),
				@UserContactAddress varchar(500),

				@Sys_CreatedByID varchar(50)= NULL,
				@Sys_ModifiedByID varchar(50) = NULL,
				@Sys_DeleteType int = 0,
				@Sys_OrganizationID int = -1,
				@Sys_InitialPrimaryKeys varchar(100)= NULL,
				@Sys_WorkstationName varchar(50)= NULL,
				
				@Sys_DateOfCreation datetime OUTPUT
	)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT OFF;

	IF @Sys_WorkstationName = 'Default'	
	BEGIN
		SET @Sys_WorkstationName = (SELECT @@SERVERNAME);
	END
	DECLARE @CurrentDataTime datetime;
	SET @CurrentDataTime = GETDATE();
	
    INSERT INTO [UserProfile]
			(
			    [UserKey],
				[UserFullName],
				[UserSex],
				[UserDateOfBirth],
				[UserAlternateEmailID],
				[UserContactNumber],
				[UserContactAddress],
				[Sys_DateOfCreation],
				[Sys_DateOfModification],
				[Sys_CreatedByID],
				[Sys_ModifiedByID],
				[Sys_DeleteType],
				[Sys_IsDeleted],
				[Sys_OrganizationID],
				[Sys_InitialPrimaryKeys],
				[Sys_WorkstationName]
		   )
     VALUES
           (
				@UserKey,
				@UserFullName,
				@UserSex,
				@UserDateOfBirth,
				@UserAlternateEmailID,
				@UserContactNumber,
				@UserContactAddress,
				@CurrentDataTime,
				@CurrentDataTime,
				@Sys_CreatedByID,
				@Sys_ModifiedByID,
				@Sys_DeleteType,
				0,
				@Sys_OrganizationID,
				@Sys_InitialPrimaryKeys,
				@Sys_WorkstationName
		   );
	SET @Sys_DateOfCreation = @CurrentDataTime;
END
